class BugStatuses < ActiveRecord::Migration
  def self.up
    query = <<-_SQL
      CREATE TABLE `bug_statuses` (
        `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
        `name` VARCHAR( 100 ) NOT NULL ,
        UNIQUE (
          `name`
        )
      ) ENGINE = MYISAM ;
    _SQL

    execute query
  end

  def self.down
    execute "DROP TABLE `bug_statuses` "
  end
end


